[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
  21.) General Tips
  -----------------

   1. The Replace-Function
   -----------------------
   On good thing about dBTools is, that you can replace Fields with other
   Fields. Al you need is to place the Character "@" before your Fieldname
   Examples (Replace-Menu):

    ------------------------------------------------------------------
    //-- Now will be replaced the Field Number by Number2 .--//
    Input1: [ Replace Fields: "NUMBER             "]
    Input2: [ New Value     : "@NUMBER2           "]

    ------------------------------------------------------------------
    //-- Now will be replaced the Field Number from DEMO1.DBF
         by the Field Number from DEMO2.DBF --//
    Input1: [ Replace Fields: "NUMBER             "]
    Input2: [ New Value     : "@DEMO2->NUMBER2    "]

    ------------------------------------------------------------------
    //-- Now will be replaced the Field Number with the
         Clipper/dBase Function "SUBSTR" --//
    Input1: [ Replace Fields: "NUMBER                "]
    Input2: [ New Value     : "@SUBSTR(NUMBER,10,20) "]


   Replacing multiple Fields:
     - You can replace multiple Fields with "+" or "," too.
       Example:
           Input1: [ Replace Fields: "NUMBER+NUMBER2+NUMBER3      "]
           Input2: [ New Value     : "22.11                       "]






   (2). The "Shift+F2" Function
   ----------------------------
    If you want to input (use) combined Fields (to make a Index) or combined
    Conditions (While, For etc..), just press Shift+F2 again and again
    and choose the Fields fpr your Syntax-Input. dBTools will automaticly
    formating you Syntax to the right Clipper/dBase Syntax.
    Example:

   -----------------------------------------------------------------------
   //-- You wnat to create a Index on NUMBER (N) and PROJECT (C).
        Please press Shift+F2 and choose Number and press Shift+F2 again
        and choose now the Field Project: --//

     Result: [ Fields.. (Sh+F2): "str(NUMBER)+PROJECT            "]

   -----------------------------------------------------------------------
   //-- You want to make a Filter for NUMBER=2 and PROJECT="HALLO".
        Please press Shift+F2 and choose Number and press Shift+F2 again
        and choose now the Field Project: --//

     Result: [ Fields.. (Sh+F2): "NUMBER=  .and. trim(PROJECT)=  "]




   (3). The Calculator
   -------------------
     With the Calculator you can combine Fields and Numbers:
     Example: [Calculate: "Number*100/2            "]
          or: [Calculate: "(Number+Number2)*100/2  "]


   (3). View-Style /Screen-Files
   -----------------------------
     If you have set at Utilties ->Settings or by pressing Alt+V,
     "View-Style" to ON, dBTools will creating automaticly to your opened
     Data-File a Screen-File with the Extension ".scr"!
     If "Autosave" is ON, all your Screen-Files will be saved, also when
     you quit dBTools, so that you can use another Time again.

     With "ViewStyle" you can desgin your Browse-Window by yourself:

      - At the Menu Utilties ->Goodies <"Show Columns"> you can set
        which Fields and what kind of Column-Width you want to see at your
        Browse-Window.
      - With Alt+(+) or Alt+(-) you cann add new Felds or remove them just
        from the Screen or from the Screen-File.
      - With Alt+Space you can set the current Column-Width.


 ----------------------------------------------------------------------------

  For any Suggetions, Questions, new Ideas, or Bug-Reports you can
  contact me under:

      Ricky Holles
      Gerechtigkeitsgasse 4
      8002 Z.rich /Schweiz
      --------------------

      CompuServe No.: 100024.2572
      Phone: (00411) 344'22'11
      Fax  : (00411) 341'22'05




 --------------------------
  Sincerely, Ricky Holles

This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson